-- Jifen added 2013.06.09 --
-- All the question will sore in this table
-- category: Different product.
-- guestion_group: identify the question belong which group
-- sort_order: a num like String for sql order by.
CREATE TABLE [dbo].[QUESTION](
	[id] [bigint] NOT NULL,
	[category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[text] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
	[question_group] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sort_order] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_QUESTION] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
);

INSERT [dbo].[QUESTION] ([id], [category], [text], [question_group], [sort_order]) VALUES (1, N'insurance', N'Unaffordable premium', N'reason', N'1001');
INSERT [dbo].[QUESTION] ([id], [category], [text], [question_group], [sort_order]) VALUES (2, N'insurance', N'Not enough coverage', N'reason', N'1002');
